package cn.jeeweb.modules.common;

public class Global {
    public static String otherSql(String orgId){
        String sql = "organization_id in (SELECT id FROM sys_organization " +
                "WHERE 1 = 1 " +
                "AND del_flag = 0 AND (id='"+orgId+"' OR parent_ids LIKE '%"+orgId+"%'))";
        return sql;
    }

    public static String treeSql(String orgId){
        String sql = "t.id='"+orgId+"' OR t.parent_ids LIKE '%"+orgId+"%'";
        return sql;
    }
}
